Re: [GENERAL] decimal_part() function

At 17:46 +0200 on 15/12/98, Sferacarta Software wrote:


> I'm looking for a function similar to dtrunc() to return the decimal
> part of a float.
>
> dtrunc(12.34) returns 12, I need something that returns 34

Here is a table having one float column named k. % is the truncation
operator (I suppose it's the same as dtrunc). so... k - %k gives you only
the fraction:

testing=> select k, %k, k - %k from test1;
    k|?column?|          ?column?
-----+--------+------------------
  1.8|       1|               0.8
 3.78|       3|              0.78
  0.4|       0|               0.4
  1.8|       1|               0.8
  0.4|       0|               0.4
 9.24|       9|              0.24
    6|       6|                 0
 9.24|       9|              0.24
  1.1|       1|               0.1
 -1.8|      -1|              -0.8
-10.2|     -10|-0.199999999999999
(11 rows)

If that's what you expect in the negative numbers, you're home free. If
not, you can use some other operator combination.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma